<CodeGroup>

```yml Snowflake
## SNOWFLAKE ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: snowflake
      account: [account id]

      ## User/password auth ##
      user: [username]
      password: [password]

      role: [user role]
      database: [database name]
      warehouse: [warehouse name]
      schema: [schema name]_elementary
      threads: 4

```

```yml BigQuery
## BIGQUERY ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: bigquery

      ## Service account auth ##
      method: service-account
      keyfile: [full path to your keyfile]

      project: [project id]
      dataset: [dataset name] # elementary dataset, usually [dataset name]_elementary
      threads: 4
      location: [dataset location]
      priority: interactive
```

```yml Redshift
## REDSHIFT ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: redshift
      host: [hostname, like hostname.region.redshift.amazonaws.com]

      ## User/password auth ##
      user: [username]
      password: [password]

      dbname: [database name]
      schema: [schema name] # elementary schema, usually [schema name]_elementary
      threads: 4
      keepalives_idle: 240 # default 240 seconds
      connect_timeout: 10 # default 10 seconds
      # search_path: public # optional, not recommended
      sslmode:
        [
          optional,
          set the sslmode used to connect to the database (in case this parameter is set,
          will look for ca in ~/.postgresql/root.crt),
        ]
      ra3_node: true # enables cross-database sources
```

```yml Databricks
## DATABRICKS ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: databricks
      host: [hostname, like <ID>.cloud.databricks.com]
      http_path: [like /sql/1.0/endpoints/<ID>]
      schema: [schema name] # elementary schema, usually [schema name]_elementary
      token: [token]
      threads: [number of threads like 8]
```

```yml Postgres
## POSTGRES ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: postgres
      host: [hostname]
      user: [username]
      password: [password]
      port: [port]
      dbname: [database name]
      schema: [schema name] # elementary schema, usually [schema name]_elementary
      threads: [1 or more]
      keepalives_idle: 0 # default 0 seconds
      connect_timeout: 10 # default 10 seconds
      # search_path: public # optional, not recommended
      # role: [optional, set the role dbt assumes when executing queries]
      # sslmode: [optional, set the sslmode used to connect to the database]
```

```yml Athena
## ATHENA ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: athena
      work_group: [athena workgroup]
      s3_staging_dir: [s3_staging_dir] # Location to store query results & metadata
      s3_data_dir: [s3 data dir] # Location to store table data (if not specified, s3_staging_dir is used)
      region_name: [aws region name] # AWS region, e.g. eu-west-1
      database: [database name]
      schema: [schema name] # elementary schema, usually [schema name]_elementary
      threads: [number of threads like 8]
```

```yml Trino
## Trino ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: trino
      host: [hostname]
      port: [port]
      database: [database name]
      schema: [schema name] # elementary schema, usually [schema name]_elementary
      threads: [1 or more]
      method: [authentication method] # ldap, oauth etc.
      user: [username]
      # password: [optional, used with ldap authentication ]
      # session_properties: [optional, sets Trino session properties used in the connection]
```

</CodeGroup>
